﻿/*
#------------------------------------------------------------------------------
#-- View Name:		[dbo].[vwCheckdbMaintenanceAudit]
#-- Purpose:		Provides a method for reviewing checkdb failures
#--	Last Update:	09/26/2011
#--					For a complete history - please review comments in SVN
#------------------------------------------------------------------------------
*/
CREATE VIEW [dbo].[vwCheckdbMaintenanceAudit]
AS

SELECT		mnt_table_catalog,
			mnt_action_date,
			mnt_action_type,
			mnt_success,
			mnt_results
FROM		dbo.tblMaintenance (NOLOCK)
WHERE		mnt_action_type = 'checkdb'
